Pandas Profiling Report

Dataset statistics

Number of variables	34
Number of observations	119210
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	8180
Duplicate rows (%)	6.9%
Total size in memory	30.9 MiB
Average record size in memory	272.0 B

Variable types

Categorical	15
Numeric	16
Text	1
DateTime	2

Alerts

Dataset has 8180 (6.9%) duplicate rows	Duplicates
`agent` is highly overall correlated with `hotel`	High correlation
`assigned_room_type` is highly overall correlated with `reserved_room_type`	High correlation
`distribution_channel` is highly overall correlated with `market_segment`	High correlation
`hotel` is highly overall correlated with `agent`	High correlation
`is_canceled` is highly overall correlated with `reservation_status` and 1 other fields	High correlation
`is_repeated_guest` is highly overall correlated with `previous_bookings_not_canceled` and 1 other fields	High correlation
`market_segment` is highly overall correlated with `distribution_channel`	High correlation
`previous_bookings_not_canceled` is highly overall correlated with `is_repeated_guest` and 1 other fields	High correlation
`previous_cancellations` is highly overall correlated with `total_bookings`	High correlation
`reservation_status` is highly overall correlated with `is_canceled` and 1 other fields	High correlation
`reserved_room_type` is highly overall correlated with `assigned_room_type`	High correlation
`stay_duration` is highly overall correlated with `is_canceled` and 1 other fields	High correlation
`total_bookings` is highly overall correlated with `is_repeated_guest` and 2 other fields	High correlation
`babies` is highly imbalanced (97.1%)	Imbalance
`meal` is highly imbalanced (53.5%)	Imbalance
`distribution_channel` is highly imbalanced (63.2%)	Imbalance
`is_repeated_guest` is highly imbalanced (79.8%)	Imbalance
`reserved_room_type` is highly imbalanced (56.3%)	Imbalance
`deposit_type` is highly imbalanced (65.3%)	Imbalance
`customer_type` is highly imbalanced (50.6%)	Imbalance
`required_car_parking_spaces` is highly imbalanced (85.4%)	Imbalance
`previous_cancellations` is highly skewed (γ1 = 24.44392359)	Skewed
`previous_bookings_not_canceled` is highly skewed (γ1 = 23.53955539)	Skewed
`lead_time` has 6264 (5.3%) zeros	Zeros
`stays_in_weekend_nights` has 51895 (43.5%) zeros	Zeros
`stays_in_week_nights` has 7572 (6.4%) zeros	Zeros
`children` has 109878 (92.2%) zeros	Zeros
`previous_cancellations` has 112731 (94.6%) zeros	Zeros
`previous_bookings_not_canceled` has 115597 (97.0%) zeros	Zeros
`booking_changes` has 101232 (84.9%) zeros	Zeros
`days_in_waiting_list` has 115517 (96.9%) zeros	Zeros
`adr` has 1810 (1.5%) zeros	Zeros
`total_of_special_requests` has 70201 (58.9%) zeros	Zeros
`total_bookings` has 109762 (92.1%) zeros	Zeros
`stay_duration` has 2717 (2.3%) zeros	Zeros

Reproduction

Analysis started	2024-02-25 19:02:29.509962
Analysis finished	2024-02-25 19:04:34.438398
Duration	2 minutes and 4.93 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

hotel
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

City Hotel	79163
Resort Hotel	40047

Length

Max length	12
Median length	10
Mean length	10.671873
Min length	10

Characters and Unicode

Total characters	1272194
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Resort Hotel
2nd row	Resort Hotel
3rd row	Resort Hotel
4th row	Resort Hotel
5th row	Resort Hotel

Common Values

Value	Count	Frequency (%)
City Hotel	79163	66.4%
Resort Hotel	40047	33.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hotel	119210	50.0%
city	79163	33.2%
resort	40047	16.8%

Most occurring characters

Value	Count	Frequency (%)
t	238420	18.7%
o	159257	12.5%
e	159257	12.5%
	119210	9.4%
H	119210	9.4%
l	119210	9.4%
C	79163	6.2%
i	79163	6.2%
y	79163	6.2%
R	40047	3.1%
Other values (2)	80094	6.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	914564	71.9%
Uppercase Letter	238420	18.7%
Space Separator	119210	9.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	238420	26.1%
o	159257	17.4%
e	159257	17.4%
l	119210	13.0%
i	79163	8.7%
y	79163	8.7%
s	40047	4.4%
r	40047	4.4%

Uppercase Letter

Value	Count	Frequency (%)
H	119210	50.0%
C	79163	33.2%
R	40047	16.8%

Space Separator

Value	Count	Frequency (%)
	119210	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1152984	90.6%
Common	119210	9.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	238420	20.7%
o	159257	13.8%
e	159257	13.8%
H	119210	10.3%
l	119210	10.3%
C	79163	6.9%
i	79163	6.9%
y	79163	6.9%
R	40047	3.5%
s	40047	3.5%

Common

Value	Count	Frequency (%)
	119210	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1272194	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	238420	18.7%
o	159257	12.5%
e	159257	12.5%
	119210	9.4%
H	119210	9.4%
l	119210	9.4%
C	79163	6.2%
i	79163	6.2%
y	79163	6.2%
R	40047	3.1%
Other values (2)	80094	6.3%

is_canceled
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

0	75011
1	44199

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119210
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	75011	62.9%
1	44199	37.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	75011	62.9%
1	44199	37.1%

Most occurring characters

Value	Count	Frequency (%)
0	75011	62.9%
1	44199	37.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119210	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	75011	62.9%
1	44199	37.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	119210	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	75011	62.9%
1	44199	37.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119210	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	75011	62.9%
1	44199	37.1%

lead_time
Real number (ℝ)

ZEROS

Distinct	479
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	104.10923

Minimum	0
Maximum	737
Zeros	6264
Zeros (%)	5.3%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	18
median	69
Q3	161
95-th percentile	320
Maximum	737
Range	737
Interquartile range (IQR)	143

Descriptive statistics

Standard deviation	106.87545
Coefficient of variation (CV)	1.0265704
Kurtosis	1.6943723
Mean	104.10923
Median Absolute Deviation (MAD)	60
Skewness	1.3458092
Sum	12410861
Variance	11422.362
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6264	5.3%
1	3445	2.9%
2	2065	1.7%
3	1815	1.5%
4	1710	1.4%
5	1563	1.3%
6	1444	1.2%
7	1329	1.1%
8	1138	1.0%
12	1079	0.9%
Other values (469)	97358	81.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6264	5.3%
1	3445	2.9%
2	2065	1.7%
3	1815	1.5%
4	1710	1.4%
5	1563	1.3%
6	1444	1.2%
7	1329	1.1%
8	1138	1.0%
9	991	0.8%

Value	Count	Frequency (%)
737	1	< 0.1%
709	1	< 0.1%
629	17	< 0.1%
626	30	< 0.1%
622	17	< 0.1%
615	17	< 0.1%
608	17	< 0.1%
605	30	< 0.1%
601	17	< 0.1%
594	17	< 0.1%

arrival_date_year
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

2016	56623
2017	40620
2015	21967

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	476840
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2015
2nd row	2015
3rd row	2015
4th row	2015
5th row	2015

Common Values

Value	Count	Frequency (%)
2016	56623	47.5%
2017	40620	34.1%
2015	21967	18.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2016	56623	47.5%
2017	40620	34.1%
2015	21967	18.4%

Most occurring characters

Value	Count	Frequency (%)
2	119210	25.0%
0	119210	25.0%
1	119210	25.0%
6	56623	11.9%
7	40620	8.5%
5	21967	4.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	476840	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	119210	25.0%
0	119210	25.0%
1	119210	25.0%
6	56623	11.9%
7	40620	8.5%
5	21967	4.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	476840	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	119210	25.0%
0	119210	25.0%
1	119210	25.0%
6	56623	11.9%
7	40620	8.5%
5	21967	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	476840	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	119210	25.0%
0	119210	25.0%
1	119210	25.0%
6	56623	11.9%
7	40620	8.5%
5	21967	4.6%

arrival_date_month
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

August	13861
July	12644
May	11780
October	11147
April	11078
Other values (7)	58700

Length

Max length	9
Median length	7
Mean length	5.9026927
Min length	3

Characters and Unicode

Total characters	703660
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	July
2nd row	July
3rd row	July
4th row	July
5th row	July

Common Values

Value	Count	Frequency (%)
August	13861	11.6%
July	12644	10.6%
May	11780	9.9%
October	11147	9.4%
April	11078	9.3%
June	10929	9.2%
September	10500	8.8%
March	9768	8.2%
February	8052	6.8%
November	6771	5.7%
Other values (2)	12680	10.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
august	13861	11.6%
july	12644	10.6%
may	11780	9.9%
october	11147	9.4%
april	11078	9.3%
june	10929	9.2%
september	10500	8.8%
march	9768	8.2%
february	8052	6.8%
november	6771	5.7%
Other values (2)	12680	10.6%

Most occurring characters

Value	Count	Frequency (%)
e	95447	13.6%
r	78048	11.1%
u	65268	9.3%
b	43229	6.1%
a	41442	5.9%
y	38397	5.5%
t	35508	5.0%
J	29494	4.2%
c	27674	3.9%
A	24939	3.5%
Other values (16)	224214	31.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	584450	83.1%
Uppercase Letter	119210	16.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	95447	16.3%
r	78048	13.4%
u	65268	11.2%
b	43229	7.4%
a	41442	7.1%
y	38397	6.6%
t	35508	6.1%
c	27674	4.7%
m	24030	4.1%
l	23722	4.1%
Other values (8)	111685	19.1%

Uppercase Letter

Value	Count	Frequency (%)
J	29494	24.7%
A	24939	20.9%
M	21548	18.1%
O	11147	9.4%
S	10500	8.8%
F	8052	6.8%
N	6771	5.7%
D	6759	5.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	703660	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	95447	13.6%
r	78048	11.1%
u	65268	9.3%
b	43229	6.1%
a	41442	5.9%
y	38397	5.5%
t	35508	5.0%
J	29494	4.2%
c	27674	3.9%
A	24939	3.5%
Other values (16)	224214	31.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	703660	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	95447	13.6%
r	78048	11.1%
u	65268	9.3%
b	43229	6.1%
a	41442	5.9%
y	38397	5.5%
t	35508	5.0%
J	29494	4.2%
c	27674	3.9%
A	24939	3.5%
Other values (16)	224214	31.9%

arrival_date_week_number
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.163376

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	16
median	28
Q3	38
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	13.601107
Coefficient of variation (CV)	0.5007149
Kurtosis	-0.98542287
Mean	27.163376
Median Absolute Deviation (MAD)	11
Skewness	-0.010198696
Sum	3238146
Variance	184.99011
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	3576	3.0%
30	3082	2.6%
32	3041	2.6%
34	3039	2.5%
18	2923	2.5%
21	2853	2.4%
28	2843	2.4%
17	2803	2.4%
20	2781	2.3%
29	2763	2.3%
Other values (43)	89506	75.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1045	0.9%
2	1216	1.0%
3	1318	1.1%
4	1485	1.2%
5	1385	1.2%
6	1507	1.3%
7	2102	1.8%
8	2212	1.9%
9	2109	1.8%
10	2142	1.8%

Value	Count	Frequency (%)
53	1811	1.5%
52	1187	1.0%
51	933	0.8%
50	1498	1.3%
49	1780	1.5%
48	1495	1.3%
47	1677	1.4%
46	1570	1.3%
45	1940	1.6%
44	2270	1.9%

arrival_date_day_of_month
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.798717

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7810701
Coefficient of variation (CV)	0.55580908
Kurtosis	-1.1870963
Mean	15.798717
Median Absolute Deviation (MAD)	8
Skewness	-0.0021109856
Sum	1883365
Variance	77.107192
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
17	4401	3.7%
5	4310	3.6%
15	4188	3.5%
25	4155	3.5%
26	4141	3.5%
9	4090	3.4%
12	4082	3.4%
16	4071	3.4%
2	4054	3.4%
19	4048	3.4%
Other values (21)	77670	65.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3620	3.0%
2	4054	3.4%
3	3847	3.2%
4	3760	3.2%
5	4310	3.6%
6	3819	3.2%
7	3658	3.1%
8	3919	3.3%
9	4090	3.4%
10	3569	3.0%

Value	Count	Frequency (%)
31	2207	1.9%
30	3844	3.2%
29	3580	3.0%
28	3942	3.3%
27	3791	3.2%
26	4141	3.5%
25	4155	3.5%
24	3983	3.3%
23	3612	3.0%
22	3593	3.0%

stays_in_weekend_nights
Real number (ℝ)

ZEROS

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.9270531

Minimum	0
Maximum	19
Zeros	51895
Zeros (%)	43.5%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	2
Maximum	19
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.99511703
Coefficient of variation (CV)	1.0734197
Kurtosis	6.3653972
Mean	0.9270531
Median Absolute Deviation (MAD)	1
Skewness	1.3202425
Sum	110514
Variance	0.9902579
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	51895	43.5%
2	33266	27.9%
1	30615	25.7%
4	1847	1.5%
3	1252	1.1%
6	152	0.1%
5	77	0.1%
8	58	< 0.1%
7	19	< 0.1%
9	10	< 0.1%
Other values (7)	19	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	51895	43.5%
1	30615	25.7%
2	33266	27.9%
3	1252	1.1%
4	1847	1.5%
5	77	0.1%
6	152	0.1%
7	19	< 0.1%
8	58	< 0.1%
9	10	< 0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
18	1	< 0.1%
16	2	< 0.1%
14	1	< 0.1%
13	2	< 0.1%
12	5	< 0.1%
10	7	< 0.1%
9	10	< 0.1%
8	58	< 0.1%
7	19	< 0.1%

stays_in_week_nights
Real number (ℝ)

ZEROS

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4991947

Minimum	0
Maximum	50
Zeros	7572
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	5
Maximum	50
Range	50
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.8971058
Coefficient of variation (CV)	0.75908683
Kurtosis	22.250866
Mean	2.4991947
Median Absolute Deviation (MAD)	1
Skewness	2.7548629
Sum	297929
Variance	3.5990103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
2	33670	28.2%
1	30292	25.4%
3	22241	18.7%
5	11068	9.3%
4	9543	8.0%
0	7572	6.4%
6	1494	1.3%
10	1030	0.9%
7	1024	0.9%
8	654	0.5%
Other values (23)	622	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7572	6.4%
1	30292	25.4%
2	33670	28.2%
3	22241	18.7%
4	9543	8.0%
5	11068	9.3%
6	1494	1.3%
7	1024	0.9%
8	654	0.5%
9	228	0.2%

Value	Count	Frequency (%)
50	1	< 0.1%
42	1	< 0.1%
40	2	< 0.1%
34	1	< 0.1%
33	1	< 0.1%
32	1	< 0.1%
30	4	< 0.1%
26	1	< 0.1%
25	6	< 0.1%
24	3	< 0.1%

adults
Real number (ℝ)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8592064

Minimum	0
Maximum	55
Zeros	223
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	55
Range	55
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.57518558
Coefficient of variation (CV)	0.30937155
Kurtosis	1392.5063
Mean	1.8592064
Median Absolute Deviation (MAD)	0
Skewness	18.774333
Sum	221636
Variance	0.33083845
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2	89680	75.2%
1	23027	19.3%
3	6202	5.2%
0	223	0.2%
4	62	0.1%
26	5	< 0.1%
27	2	< 0.1%
20	2	< 0.1%
5	2	< 0.1%
40	1	< 0.1%
Other values (4)	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	223	0.2%
1	23027	19.3%
2	89680	75.2%
3	6202	5.2%
4	62	0.1%
5	2	< 0.1%
6	1	< 0.1%
10	1	< 0.1%
20	2	< 0.1%
26	5	< 0.1%

Value	Count	Frequency (%)
55	1	< 0.1%
50	1	< 0.1%
40	1	< 0.1%
27	2	< 0.1%
26	5	< 0.1%
20	2	< 0.1%
10	1	< 0.1%
6	1	< 0.1%
5	2	< 0.1%
4	62	0.1%

children
Real number (ℝ)

ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.11200403

Minimum	0
Maximum	10
Zeros	109878
Zeros (%)	92.2%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.41284929
Coefficient of variation (CV)	3.6860218
Kurtosis	21.375007
Mean	0.11200403
Median Absolute Deviation (MAD)	0
Skewness	4.0953519
Sum	13352
Variance	0.17044453
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	109878	92.2%
1	5446	4.6%
2	3772	3.2%
3	111	0.1%
10	2	< 0.1%
9	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	109878	92.2%
1	5446	4.6%
2	3772	3.2%
3	111	0.1%
9	1	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
10	2	< 0.1%
9	1	< 0.1%
3	111	0.1%
2	3772	3.2%
1	5446	4.6%
0	109878	92.2%

babies
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

0	118293
1	900
2	15
10	1
9	1

Length

Max length	2
Median length	1
Mean length	1.0000084
Min length	1

Characters and Unicode

Total characters	119211
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	118293	99.2%
1	900	0.8%
2	15	< 0.1%
10	1	< 0.1%
9	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	118293	99.2%
1	900	0.8%
2	15	< 0.1%
10	1	< 0.1%
9	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	118294	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119211	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	118294	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	119211	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	118294	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119211	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	118294	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

meal
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

BB	92236
HB	14458
SC	10549
Undefined	1169
FB	798

Length

Max length	9
Median length	2
Mean length	2.0686436
Min length	2

Characters and Unicode

Total characters	246603
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BB
2nd row	BB
3rd row	BB
4th row	BB
5th row	BB

Common Values

Value	Count	Frequency (%)
BB	92236	77.4%
HB	14458	12.1%
SC	10549	8.8%
Undefined	1169	1.0%
FB	798	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bb	92236	77.4%
hb	14458	12.1%
sc	10549	8.8%
undefined	1169	1.0%
fb	798	0.7%

Most occurring characters

Value	Count	Frequency (%)
B	199728	81.0%
H	14458	5.9%
S	10549	4.3%
C	10549	4.3%
n	2338	0.9%
d	2338	0.9%
e	2338	0.9%
U	1169	0.5%
f	1169	0.5%
i	1169	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	237251	96.2%
Lowercase Letter	9352	3.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	199728	84.2%
H	14458	6.1%
S	10549	4.4%
C	10549	4.4%
U	1169	0.5%
F	798	0.3%

Lowercase Letter

Value	Count	Frequency (%)
n	2338	25.0%
d	2338	25.0%
e	2338	25.0%
f	1169	12.5%
i	1169	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	246603	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	199728	81.0%
H	14458	5.9%
S	10549	4.3%
C	10549	4.3%
n	2338	0.9%
d	2338	0.9%
e	2338	0.9%
U	1169	0.5%
f	1169	0.5%
i	1169	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	246603	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	199728	81.0%
H	14458	5.9%
S	10549	4.3%
C	10549	4.3%
n	2338	0.9%
d	2338	0.9%
e	2338	0.9%
U	1169	0.5%
f	1169	0.5%
i	1169	0.5%

country
Text

Distinct	177
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Length

Max length	3
Median length	3
Mean length	2.989271
Min length	2

Characters and Unicode

Total characters	356351
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	30 ?
Unique (%)	< 0.1%

Sample

1st row	PRT
2nd row	PRT
3rd row	GBR
4th row	GBR
5th row	GBR

Value	Count	Frequency (%)
prt	48961	41.1%
gbr	12120	10.2%
fra	10401	8.7%
esp	8560	7.2%
deu	7285	6.1%
ita	3761	3.2%
irl	3374	2.8%
bel	2342	2.0%
bra	2222	1.9%
nld	2103	1.8%
Other values (167)	18081	15.2%

Most occurring characters

Value	Count	Frequency (%)
R	81146	22.8%
P	58867	16.5%
T	54629	15.3%
A	21602	6.1%
E	21520	6.0%
B	17040	4.8%
S	13911	3.9%
U	13284	3.7%
G	13120	3.7%
F	10941	3.1%
Other values (16)	50291	14.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	356351	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	81146	22.8%
P	58867	16.5%
T	54629	15.3%
A	21602	6.1%
E	21520	6.0%
B	17040	4.8%
S	13911	3.9%
U	13284	3.7%
G	13120	3.7%
F	10941	3.1%
Other values (16)	50291	14.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	356351	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	81146	22.8%
P	58867	16.5%
T	54629	15.3%
A	21602	6.1%
E	21520	6.0%
B	17040	4.8%
S	13911	3.9%
U	13284	3.7%
G	13120	3.7%
F	10941	3.1%
Other values (16)	50291	14.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	356351	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	81146	22.8%
P	58867	16.5%
T	54629	15.3%
A	21602	6.1%
E	21520	6.0%
B	17040	4.8%
S	13911	3.9%
U	13284	3.7%
G	13120	3.7%
F	10941	3.1%
Other values (16)	50291	14.1%

market_segment
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Online TA	56408
Offline TA/TO	24182
Groups	19791
Direct	12582
Corporate	5282
Other values (3)	965

Length

Max length	13
Median length	9
Mean length	9.0191762
Min length	6

Characters and Unicode

Total characters	1075176
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct
2nd row	Direct
3rd row	Direct
4th row	Corporate
5th row	Online TA

Common Values

Value	Count	Frequency (%)
Online TA	56408	47.3%
Offline TA/TO	24182	20.3%
Groups	19791	16.6%
Direct	12582	10.6%
Corporate	5282	4.4%
Complementary	728	0.6%
Aviation	235	0.2%
Undefined	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
online	56408	28.2%
ta	56408	28.2%
offline	24182	12.1%
ta/to	24182	12.1%
groups	19791	9.9%
direct	12582	6.3%
corporate	5282	2.6%
complementary	728	0.4%
aviation	235	0.1%
undefined	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
n	137965	12.8%
O	104772	9.7%
T	104772	9.7%
e	99914	9.3%
i	93644	8.7%
l	81318	7.6%
A	80825	7.5%
	80590	7.5%
f	48366	4.5%
r	43665	4.1%
Other values (16)	199345	18.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	641650	59.7%
Uppercase Letter	328754	30.6%
Space Separator	80590	7.5%
Other Punctuation	24182	2.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	137965	21.5%
e	99914	15.6%
i	93644	14.6%
l	81318	12.7%
f	48366	7.5%
r	43665	6.8%
o	31318	4.9%
p	25801	4.0%
s	19791	3.1%
u	19791	3.1%
Other values (7)	40077	6.2%

Uppercase Letter

Value	Count	Frequency (%)
O	104772	31.9%
T	104772	31.9%
A	80825	24.6%
G	19791	6.0%
D	12582	3.8%
C	6010	1.8%
U	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	80590	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	24182	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	970404	90.3%
Common	104772	9.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	137965	14.2%
O	104772	10.8%
T	104772	10.8%
e	99914	10.3%
i	93644	9.7%
l	81318	8.4%
A	80825	8.3%
f	48366	5.0%
r	43665	4.5%
o	31318	3.2%
Other values (14)	143845	14.8%

Common

Value	Count	Frequency (%)
	80590	76.9%
/	24182	23.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1075176	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	137965	12.8%
O	104772	9.7%
T	104772	9.7%
e	99914	9.3%
i	93644	8.7%
l	81318	7.6%
A	80825	7.5%
	80590	7.5%
f	48366	4.5%
r	43665	4.1%
Other values (16)	199345	18.5%

distribution_channel
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

TA/TO	97750
Direct	14611
Corporate	6651
GDS	193
Undefined	5

Length

Max length	9
Median length	5
Mean length	5.3426642
Min length	3

Characters and Unicode

Total characters	636899
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct
2nd row	Direct
3rd row	Direct
4th row	Corporate
5th row	TA/TO

Common Values

Value	Count	Frequency (%)
TA/TO	97750	82.0%
Direct	14611	12.3%
Corporate	6651	5.6%
GDS	193	0.2%
Undefined	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ta/to	97750	82.0%
direct	14611	12.3%
corporate	6651	5.6%
gds	193	0.2%
undefined	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
T	195500	30.7%
/	97750	15.3%
O	97750	15.3%
A	97750	15.3%
r	27913	4.4%
e	21272	3.3%
t	21262	3.3%
D	14804	2.3%
i	14616	2.3%
c	14611	2.3%
Other values (10)	33671	5.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	412846	64.8%
Lowercase Letter	126303	19.8%
Other Punctuation	97750	15.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	27913	22.1%
e	21272	16.8%
t	21262	16.8%
i	14616	11.6%
c	14611	11.6%
o	13302	10.5%
a	6651	5.3%
p	6651	5.3%
n	10	< 0.1%
d	10	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
T	195500	47.4%
O	97750	23.7%
A	97750	23.7%
D	14804	3.6%
C	6651	1.6%
G	193	< 0.1%
S	193	< 0.1%
U	5	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	97750	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	539149	84.7%
Common	97750	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	195500	36.3%
O	97750	18.1%
A	97750	18.1%
r	27913	5.2%
e	21272	3.9%
t	21262	3.9%
D	14804	2.7%
i	14616	2.7%
c	14611	2.7%
o	13302	2.5%
Other values (9)	20369	3.8%

Common

Value	Count	Frequency (%)
/	97750	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	636899	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	195500	30.7%
/	97750	15.3%
O	97750	15.3%
A	97750	15.3%
r	27913	4.4%
e	21272	3.3%
t	21262	3.3%
D	14804	2.3%
i	14616	2.3%
c	14611	2.3%
Other values (10)	33671	5.3%

is_repeated_guest
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

0	115455
1	3755

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119210
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	115455	96.9%
1	3755	3.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	115455	96.9%
1	3755	3.1%

Most occurring characters

Value	Count	Frequency (%)
0	115455	96.9%
1	3755	3.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119210	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	115455	96.9%
1	3755	3.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	119210	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	115455	96.9%
1	3755	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119210	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	115455	96.9%
1	3755	3.1%

previous_cancellations
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.087190672

Minimum	0
Maximum	26
Zeros	112731
Zeros (%)	94.6%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	26
Range	26
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.84491826
Coefficient of variation (CV)	9.6904663
Kurtosis	673.22115
Mean	0.087190672
Median Absolute Deviation (MAD)	0
Skewness	24.443924
Sum	10394
Variance	0.71388687
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	112731	94.6%
1	6048	5.1%
2	114	0.1%
3	65	0.1%
24	48	< 0.1%
11	35	< 0.1%
4	31	< 0.1%
26	26	< 0.1%
25	25	< 0.1%
6	22	< 0.1%
Other values (5)	65	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	112731	94.6%
1	6048	5.1%
2	114	0.1%
3	65	0.1%
4	31	< 0.1%
5	19	< 0.1%
6	22	< 0.1%
11	35	< 0.1%
13	12	< 0.1%
14	14	< 0.1%

Value	Count	Frequency (%)
26	26	< 0.1%
25	25	< 0.1%
24	48	< 0.1%
21	1	< 0.1%
19	19	< 0.1%
14	14	< 0.1%
13	12	< 0.1%
11	35	< 0.1%
6	22	< 0.1%
5	19	< 0.1%

previous_bookings_not_canceled
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	73
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1370942

Minimum	0
Maximum	72
Zeros	115597
Zeros (%)	97.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	72
Range	72
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.4981372
Coefficient of variation (CV)	10.927794
Kurtosis	766.95283
Mean	0.1370942
Median Absolute Deviation (MAD)	0
Skewness	23.539555
Sum	16343
Variance	2.244415
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	115597	97.0%
1	1538	1.3%
2	580	0.5%
3	333	0.3%
4	229	0.2%
5	181	0.2%
6	113	0.1%
7	88	0.1%
8	70	0.1%
9	59	< 0.1%
Other values (63)	422	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	115597	97.0%
1	1538	1.3%
2	580	0.5%
3	333	0.3%
4	229	0.2%
5	181	0.2%
6	113	0.1%
7	88	0.1%
8	70	0.1%
9	59	< 0.1%

Value	Count	Frequency (%)
72	1	< 0.1%
71	1	< 0.1%
70	1	< 0.1%
69	1	< 0.1%
68	1	< 0.1%
67	1	< 0.1%
66	1	< 0.1%
65	1	< 0.1%
64	1	< 0.1%
63	1	< 0.1%

reserved_room_type
Categorical

HIGH CORRELATION IMBALANCE

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

A	85873
D	19179
E	6519
F	2894
G	2092
Other values (4)	2653

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119210
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	C
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	85873	72.0%
D	19179	16.1%
E	6519	5.5%
F	2894	2.4%
G	2092	1.8%
B	1115	0.9%
C	931	0.8%
H	601	0.5%
L	6	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	85873	72.0%
d	19179	16.1%
e	6519	5.5%
f	2894	2.4%
g	2092	1.8%
b	1115	0.9%
c	931	0.8%
h	601	0.5%
l	6	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	85873	72.0%
D	19179	16.1%
E	6519	5.5%
F	2894	2.4%
G	2092	1.8%
B	1115	0.9%
C	931	0.8%
H	601	0.5%
L	6	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	119210	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	85873	72.0%
D	19179	16.1%
E	6519	5.5%
F	2894	2.4%
G	2092	1.8%
B	1115	0.9%
C	931	0.8%
H	601	0.5%
L	6	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119210	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	85873	72.0%
D	19179	16.1%
E	6519	5.5%
F	2894	2.4%
G	2092	1.8%
B	1115	0.9%
C	931	0.8%
H	601	0.5%
L	6	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119210	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	85873	72.0%
D	19179	16.1%
E	6519	5.5%
F	2894	2.4%
G	2092	1.8%
B	1115	0.9%
C	931	0.8%
H	601	0.5%
L	6	< 0.1%

assigned_room_type
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

A	74020
D	25309
E	7798
F	3751
G	2549
Other values (6)	5783

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119210
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	C
2nd row	C
3rd row	C
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	74020	62.1%
D	25309	21.2%
E	7798	6.5%
F	3751	3.1%
G	2549	2.1%
C	2370	2.0%
B	2154	1.8%
H	712	0.6%
I	359	0.3%
K	187	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	74020	62.1%
d	25309	21.2%
e	7798	6.5%
f	3751	3.1%
g	2549	2.1%
c	2370	2.0%
b	2154	1.8%
h	712	0.6%
i	359	0.3%
k	187	0.2%

Most occurring characters

Value	Count	Frequency (%)
A	74020	62.1%
D	25309	21.2%
E	7798	6.5%
F	3751	3.1%
G	2549	2.1%
C	2370	2.0%
B	2154	1.8%
H	712	0.6%
I	359	0.3%
K	187	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	119210	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	74020	62.1%
D	25309	21.2%
E	7798	6.5%
F	3751	3.1%
G	2549	2.1%
C	2370	2.0%
B	2154	1.8%
H	712	0.6%
I	359	0.3%
K	187	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119210	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	74020	62.1%
D	25309	21.2%
E	7798	6.5%
F	3751	3.1%
G	2549	2.1%
C	2370	2.0%
B	2154	1.8%
H	712	0.6%
I	359	0.3%
K	187	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119210	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	74020	62.1%
D	25309	21.2%
E	7798	6.5%
F	3751	3.1%
G	2549	2.1%
C	2370	2.0%
B	2154	1.8%
H	712	0.6%
I	359	0.3%
K	187	0.2%

booking_changes
Real number (ℝ)

ZEROS

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.21879876

Minimum	0
Maximum	18
Zeros	101232
Zeros (%)	84.9%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	18
Range	18
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.63850446
Coefficient of variation (CV)	2.9182271
Kurtosis	63.437992
Mean	0.21879876
Median Absolute Deviation (MAD)	0
Skewness	5.5000578
Sum	26083
Variance	0.40768794
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0	101232	84.9%
1	12666	10.6%
2	3780	3.2%
3	914	0.8%
4	367	0.3%
5	115	0.1%
6	61	0.1%
7	29	< 0.1%
8	14	< 0.1%
9	8	< 0.1%
Other values (9)	24	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	101232	84.9%
1	12666	10.6%
2	3780	3.2%
3	914	0.8%
4	367	0.3%
5	115	0.1%
6	61	0.1%
7	29	< 0.1%
8	14	< 0.1%
9	8	< 0.1%

Value	Count	Frequency (%)
18	1	< 0.1%
17	2	< 0.1%
16	2	< 0.1%
15	3	< 0.1%
14	3	< 0.1%
13	5	< 0.1%
12	1	< 0.1%
11	1	< 0.1%
10	6	< 0.1%
9	8	< 0.1%

deposit_type
Categorical

IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

No Deposit	104461
Non Refund	14587
Refundable	162

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1192100
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Deposit
2nd row	No Deposit
3rd row	No Deposit
4th row	No Deposit
5th row	No Deposit

Common Values

Value	Count	Frequency (%)
No Deposit	104461	87.6%
Non Refund	14587	12.2%
Refundable	162	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	104461	43.8%
deposit	104461	43.8%
non	14587	6.1%
refund	14587	6.1%
refundable	162	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	223509	18.7%
e	119372	10.0%
N	119048	10.0%
	119048	10.0%
s	104461	8.8%
i	104461	8.8%
t	104461	8.8%
p	104461	8.8%
D	104461	8.8%
n	29336	2.5%
Other values (7)	59482	5.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	834794	70.0%
Uppercase Letter	238258	20.0%
Space Separator	119048	10.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	223509	26.8%
e	119372	14.3%
s	104461	12.5%
i	104461	12.5%
t	104461	12.5%
p	104461	12.5%
n	29336	3.5%
f	14749	1.8%
u	14749	1.8%
d	14749	1.8%
Other values (3)	486	0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	119048	50.0%
D	104461	43.8%
R	14749	6.2%

Space Separator

Value	Count	Frequency (%)
	119048	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1073052	90.0%
Common	119048	10.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	223509	20.8%
e	119372	11.1%
N	119048	11.1%
s	104461	9.7%
i	104461	9.7%
t	104461	9.7%
p	104461	9.7%
D	104461	9.7%
n	29336	2.7%
R	14749	1.4%
Other values (6)	44733	4.2%

Common

Value	Count	Frequency (%)
	119048	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1192100	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	223509	18.7%
e	119372	10.0%
N	119048	10.0%
	119048	10.0%
s	104461	8.8%
i	104461	8.8%
t	104461	8.8%
p	104461	8.8%
D	104461	8.8%
n	29336	2.5%
Other values (7)	59482	5.0%

agent
Real number (ℝ)

HIGH CORRELATION

Distinct	333
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.11817

Minimum	1
Maximum	535
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	9
median	9
Q3	152
95-th percentile	250
Maximum	535
Range	534
Interquartile range (IQR)	143

Descriptive statistics

Standard deviation	106.35144
Coefficient of variation (CV)	1.3971886
Kurtosis	0.54174967
Mean	76.11817
Median Absolute Deviation (MAD)	5
Skewness	1.3092548
Sum	9074047
Variance	11310.628
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	48202	40.4%
240	13922	11.7%
1	7187	6.0%
14	3633	3.0%
7	3532	3.0%
6	3290	2.8%
250	2870	2.4%
241	1721	1.4%
28	1657	1.4%
8	1514	1.3%
Other values (323)	31682	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7187	6.0%
2	162	0.1%
3	1336	1.1%
4	47	< 0.1%
5	330	0.3%
6	3290	2.8%
7	3532	3.0%
8	1514	1.3%
9	48202	40.4%
10	260	0.2%

Value	Count	Frequency (%)
535	3	< 0.1%
531	68	0.1%
527	35	< 0.1%
526	10	< 0.1%
510	2	< 0.1%
509	10	< 0.1%
508	6	< 0.1%
502	24	< 0.1%
497	1	< 0.1%
495	57	< 0.1%

days_in_waiting_list
Real number (ℝ)

ZEROS

Distinct	127
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.3212147

Minimum	0
Maximum	391
Zeros	115517
Zeros (%)	96.9%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	391
Range	391
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	17.598002
Coefficient of variation (CV)	7.5813763
Kurtosis	186.89459
Mean	2.3212147
Median Absolute Deviation (MAD)	0
Skewness	11.948868
Sum	276712
Variance	309.68967
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	115517	96.9%
39	227	0.2%
58	164	0.1%
44	141	0.1%
31	127	0.1%
35	96	0.1%
46	94	0.1%
69	89	0.1%
63	83	0.1%
87	80	0.1%
Other values (117)	2592	2.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	115517	96.9%
1	12	< 0.1%
2	5	< 0.1%
3	59	< 0.1%
4	25	< 0.1%
5	8	< 0.1%
6	15	< 0.1%
7	4	< 0.1%
8	7	< 0.1%
9	16	< 0.1%

Value	Count	Frequency (%)
391	45	< 0.1%
379	15	< 0.1%
330	15	< 0.1%
259	10	< 0.1%
236	35	< 0.1%
224	10	< 0.1%
223	61	0.1%
215	21	< 0.1%
207	15	< 0.1%
193	1	< 0.1%

customer_type
Categorical

IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Transient	89476
Transient-Party	25088
Contract	4072
Group	574

Length

Max length	15
Median length	9
Mean length	10.209295
Min length	5

Characters and Unicode

Total characters	1217050
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Transient
2nd row	Transient
3rd row	Transient
4th row	Transient
5th row	Transient

Common Values

Value	Count	Frequency (%)
Transient	89476	75.1%
Transient-Party	25088	21.0%
Contract	4072	3.4%
Group	574	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
transient	89476	75.1%
transient-party	25088	21.0%
contract	4072	3.4%
group	574	0.5%

Most occurring characters

Value	Count	Frequency (%)
n	233200	19.2%
t	147796	12.1%
r	144298	11.9%
a	143724	11.8%
T	114564	9.4%
s	114564	9.4%
i	114564	9.4%
e	114564	9.4%
y	25088	2.1%
-	25088	2.1%
Other values (7)	39600	3.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1047664	86.1%
Uppercase Letter	144298	11.9%
Dash Punctuation	25088	2.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	233200	22.3%
t	147796	14.1%
r	144298	13.8%
a	143724	13.7%
s	114564	10.9%
i	114564	10.9%
e	114564	10.9%
y	25088	2.4%
o	4646	0.4%
c	4072	0.4%
Other values (2)	1148	0.1%

Uppercase Letter

Value	Count	Frequency (%)
T	114564	79.4%
P	25088	17.4%
C	4072	2.8%
G	574	0.4%

Dash Punctuation

Value	Count	Frequency (%)
-	25088	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1191962	97.9%
Common	25088	2.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	233200	19.6%
t	147796	12.4%
r	144298	12.1%
a	143724	12.1%
T	114564	9.6%
s	114564	9.6%
i	114564	9.6%
e	114564	9.6%
y	25088	2.1%
P	25088	2.1%
Other values (6)	14512	1.2%

Common

Value	Count	Frequency (%)
-	25088	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1217050	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	233200	19.2%
t	147796	12.1%
r	144298	11.9%
a	143724	11.8%
T	114564	9.4%
s	114564	9.4%
i	114564	9.4%
e	114564	9.4%
y	25088	2.1%
-	25088	2.1%
Other values (7)	39600	3.3%

adr
Real number (ℝ)

ZEROS

Distinct	8866
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	101.96909

Minimum	-6.38
Maximum	5400
Zeros	1810
Zeros (%)	1.5%
Negative	1
Negative (%)	< 0.1%
Memory size	1.8 MiB

Quantile statistics

Minimum	-6.38
5-th percentile	39
Q1	69.5
median	94.95
Q3	126
95-th percentile	193.5
Maximum	5400
Range	5406.38
Interquartile range (IQR)	56.5

Descriptive statistics

Standard deviation	50.434007
Coefficient of variation (CV)	0.49460092
Kurtosis	1022.8267
Mean	101.96909
Median Absolute Deviation (MAD)	27.95
Skewness	10.612728
Sum	12155735
Variance	2543.589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	3754	3.1%
75	2715	2.3%
90	2472	2.1%
65	2418	2.0%
80	1889	1.6%
0	1810	1.5%
95	1661	1.4%
120	1607	1.3%
100	1573	1.3%
85	1538	1.3%
Other values (8856)	97773	82.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.38	1	< 0.1%
0	1810	1.5%
0.26	1	< 0.1%
0.5	1	< 0.1%
1	14	< 0.1%
1.48	1	< 0.1%
1.56	2	< 0.1%
1.6	1	< 0.1%
1.8	1	< 0.1%
2	12	< 0.1%

Value	Count	Frequency (%)
5400	1	< 0.1%
510	1	< 0.1%
508	1	< 0.1%
451.5	1	< 0.1%
450	1	< 0.1%
437	1	< 0.1%
426.25	1	< 0.1%
402	1	< 0.1%
397.38	1	< 0.1%
392	2	< 0.1%

required_car_parking_spaces
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

0	111801
1	7376
2	28
3	3
8	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119210
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	111801	93.8%
1	7376	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	111801	93.8%
1	7376	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	111801	93.8%
1	7376	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119210	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	111801	93.8%
1	7376	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	119210	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	111801	93.8%
1	7376	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119210	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	111801	93.8%
1	7376	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

total_of_special_requests
Real number (ℝ)

ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.57150407

Minimum	0
Maximum	5
Zeros	70201
Zeros (%)	58.9%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7928759
Coefficient of variation (CV)	1.3873495
Kurtosis	1.4926142
Mean	0.57150407
Median Absolute Deviation (MAD)	0
Skewness	1.3490487
Sum	68129
Variance	0.62865219
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	70201	58.9%
1	33183	27.8%
2	12952	10.9%
3	2494	2.1%
4	340	0.3%
5	40	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	70201	58.9%
1	33183	27.8%
2	12952	10.9%
3	2494	2.1%
4	340	0.3%
5	40	< 0.1%

Value	Count	Frequency (%)
5	40	< 0.1%
4	340	0.3%
3	2494	2.1%
2	12952	10.9%
1	33183	27.8%
0	70201	58.9%

reservation_status
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Check-Out	75011
Canceled	42993
No-Show	1206

Length

Max length	9
Median length	9
Mean length	8.6191175
Min length	7

Characters and Unicode

Total characters	1027485
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Check-Out
2nd row	Check-Out
3rd row	Check-Out
4th row	Check-Out
5th row	Check-Out

Common Values

Value	Count	Frequency (%)
Check-Out	75011	62.9%
Canceled	42993	36.1%
No-Show	1206	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
check-out	75011	62.9%
canceled	42993	36.1%
no-show	1206	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	160997	15.7%
C	118004	11.5%
c	118004	11.5%
h	76217	7.4%
-	76217	7.4%
u	75011	7.3%
t	75011	7.3%
O	75011	7.3%
k	75011	7.3%
a	42993	4.2%
Other values (7)	135009	13.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	755841	73.6%
Uppercase Letter	195427	19.0%
Dash Punctuation	76217	7.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	160997	21.3%
c	118004	15.6%
h	76217	10.1%
u	75011	9.9%
t	75011	9.9%
k	75011	9.9%
a	42993	5.7%
n	42993	5.7%
l	42993	5.7%
d	42993	5.7%
Other values (2)	3618	0.5%

Uppercase Letter

Value	Count	Frequency (%)
C	118004	60.4%
O	75011	38.4%
N	1206	0.6%
S	1206	0.6%

Dash Punctuation

Value	Count	Frequency (%)
-	76217	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	951268	92.6%
Common	76217	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	160997	16.9%
C	118004	12.4%
c	118004	12.4%
h	76217	8.0%
u	75011	7.9%
t	75011	7.9%
O	75011	7.9%
k	75011	7.9%
a	42993	4.5%
n	42993	4.5%
Other values (6)	92016	9.7%

Common

Value	Count	Frequency (%)
-	76217	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1027485	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	160997	15.7%
C	118004	11.5%
c	118004	11.5%
h	76217	7.4%
-	76217	7.4%
u	75011	7.3%
t	75011	7.3%
O	75011	7.3%
k	75011	7.3%
a	42993	4.2%
Other values (7)	135009	13.1%

reservation_status_date
Date

Distinct	926
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Minimum	2014-10-17 00:00:00
Maximum	2017-09-14 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

arrival_date
Date

Distinct	793
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Minimum	2015-07-01 00:00:00
Maximum	2017-08-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

total_bookings
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	77
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.22428488

Minimum	0
Maximum	78
Zeros	109762
Zeros (%)	92.1%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	78
Range	78
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.8288107
Coefficient of variation (CV)	8.1539636
Kurtosis	521.5149
Mean	0.22428488
Median Absolute Deviation (MAD)	0
Skewness	19.276343
Sum	26737
Variance	3.3445486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	109762	92.1%
1	7119	6.0%
2	609	0.5%
3	336	0.3%
4	235	0.2%
5	170	0.1%
6	130	0.1%
7	91	0.1%
8	77	0.1%
9	65	0.1%
Other values (67)	616	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	109762	92.1%
1	7119	6.0%
2	609	0.5%
3	336	0.3%
4	235	0.2%
5	170	0.1%
6	130	0.1%
7	91	0.1%
8	77	0.1%
9	65	0.1%

Value	Count	Frequency (%)
78	1	< 0.1%
77	1	< 0.1%
76	1	< 0.1%
75	1	< 0.1%
74	1	< 0.1%
73	1	< 0.1%
72	1	< 0.1%
71	1	< 0.1%
70	1	< 0.1%
69	1	< 0.1%

stay_duration
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	40
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.7780975

Minimum	-1
Maximum	69
Zeros	2717
Zeros (%)	2.3%
Negative	42129
Negative (%)	35.3%
Memory size	1.4 MiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	1
Q3	3
95-th percentile	7
Maximum	69
Range	70
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.9161384
Coefficient of variation (CV)	1.6400329
Kurtosis	12.134098
Mean	1.7780975
Median Absolute Deviation (MAD)	2
Skewness	1.8582684
Sum	211967
Variance	8.5038631
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
-1	42129	35.3%
1	15732	13.2%
3	15716	13.2%
2	15470	13.0%
4	11014	9.2%
7	5672	4.8%
5	5107	4.3%
0	2717	2.3%
6	2316	1.9%
10	776	0.7%
Other values (30)	2561	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	42129	35.3%
0	2717	2.3%
1	15732	13.2%
2	15470	13.0%
3	15716	13.2%
4	11014	9.2%
5	5107	4.3%
6	2316	1.9%
7	5672	4.8%
8	713	0.6%

Value	Count	Frequency (%)
69	1	< 0.1%
60	1	< 0.1%
56	1	< 0.1%
48	1	< 0.1%
46	1	< 0.1%
45	1	< 0.1%
42	3	< 0.1%
38	1	< 0.1%
35	5	< 0.1%
34	1	< 0.1%

Auto

Heatmap
Table

	adr	adults	agent	arrival_date_day_of_month	arrival_date_month	arrival_date_week_number	arrival_date_year	assigned_room_type	babies	booking_changes	children	customer_type	days_in_waiting_list	deposit_type	distribution_channel	hotel	is_canceled	is_repeated_guest	lead_time	market_segment	meal	previous_bookings_not_canceled	previous_cancellations	required_car_parking_spaces	reservation_status	reserved_room_type	stay_duration	stays_in_week_nights	stays_in_weekend_nights	total_bookings	total_of_special_requests
adr	1.000	0.276	-0.005	0.027	0.001	0.074	0.000	0.000	0.000	0.008	0.260	0.000	-0.040	0.007	0.000	0.000	0.000	0.000	0.013	0.000	0.000	-0.143	-0.150	0.000	0.000	0.000	-0.010	0.093	0.051	-0.200	0.197
adults	0.276	1.000	0.003	0.001	0.010	0.027	0.015	0.000	0.000	-0.081	0.076	0.090	-0.037	0.000	0.008	0.014	0.013	0.000	0.190	0.008	0.000	-0.210	-0.037	0.000	0.008	0.004	0.033	0.153	0.127	-0.139	0.162
agent	-0.005	0.003	1.000	0.004	0.076	-0.045	0.084	0.115	0.022	0.059	0.053	0.112	0.000	0.105	0.158	0.686	0.060	0.049	-0.054	0.187	0.163	-0.035	-0.154	0.087	0.046	0.121	0.138	0.180	0.145	-0.142	0.035
arrival_date_day_of_month	0.027	0.001	0.004	1.000	0.058	0.061	0.044	0.009	0.005	0.012	0.015	0.032	0.032	0.054	0.028	0.025	0.021	0.018	0.008	0.033	0.039	-0.002	-0.012	0.008	0.023	0.010	0.002	-0.016	-0.007	-0.011	0.003
arrival_date_month	0.001	0.010	0.076	0.058	1.000	0.337	0.429	0.028	0.016	-0.016	-0.090	0.103	0.039	0.101	0.069	0.070	0.069	0.073	0.057	0.088	0.089	-0.008	0.046	0.018	0.065	0.048	-0.008	-0.024	-0.035	0.034	-0.057
arrival_date_week_number	0.074	0.027	-0.045	0.061	0.337	1.000	0.424	0.027	0.014	0.008	0.010	0.106	-0.004	0.095	0.064	0.068	0.065	0.074	0.113	0.081	0.080	-0.044	0.087	0.017	0.061	0.044	0.009	0.026	0.026	0.048	0.019
arrival_date_year	0.000	0.015	0.084	0.044	0.429	0.424	1.000	0.053	0.009	0.023	0.052	0.213	-0.083	0.052	0.027	0.043	0.026	0.009	0.057	0.159	0.112	0.037	-0.258	0.018	0.023	0.082	-0.008	0.042	0.025	-0.194	0.116
assigned_room_type	0.000	0.000	0.115	0.009	0.028	0.027	0.053	1.000	0.044	0.096	0.261	0.090	-0.099	0.192	0.095	0.391	0.201	0.060	-0.158	0.118	0.113	0.041	-0.139	0.092	0.144	0.744	0.181	0.083	0.080	-0.089	0.137
babies	0.000	0.000	0.022	0.005	0.016	0.014	0.009	0.044	1.000	0.117	0.297	0.015	-0.014	0.023	0.029	0.049	0.034	0.007	-0.020	0.034	0.015	-0.011	-0.017	0.020	0.024	0.040	0.042	0.026	0.023	-0.020	0.093
booking_changes	0.008	-0.081	0.059	0.012	-0.016	0.008	0.023	0.096	0.117	1.000	0.094	0.038	-0.019	0.057	0.041	0.049	0.079	0.001	-0.007	0.029	0.012	0.031	-0.073	0.026	0.057	0.018	0.193	0.063	0.039	-0.043	0.042
children	0.260	0.076	0.053	0.015	-0.090	0.010	0.052	0.261	0.297	0.094	1.000	0.041	-0.050	0.048	0.031	0.045	0.016	0.023	-0.021	0.074	0.026	-0.037	-0.061	0.022	0.018	0.337	0.028	0.059	0.058	-0.069	0.117
customer_type	0.000	0.090	0.112	0.032	0.103	0.106	0.213	0.090	0.015	0.038	0.041	1.000	0.106	0.098	0.080	0.052	0.137	0.106	0.125	0.275	0.139	-0.049	0.002	0.041	0.097	0.109	0.049	-0.080	-0.083	-0.026	-0.160
days_in_waiting_list	-0.040	-0.037	0.000	0.032	0.039	-0.004	-0.083	-0.099	-0.014	-0.019	-0.050	0.106	1.000	0.128	0.027	0.087	0.068	0.024	0.153	0.078	0.062	-0.019	0.116	0.034	0.050	0.028	-0.087	0.012	-0.075	0.083	-0.123
deposit_type	0.007	0.000	0.105	0.054	0.101	0.095	0.052	0.192	0.023	0.057	0.048	0.098	0.128	1.000	0.091	0.177	0.482	0.058	0.331	0.374	0.093	-0.064	0.318	0.071	0.347	0.152	-0.421	-0.056	-0.116	0.229	-0.302
distribution_channel	0.000	0.008	0.158	0.028	0.069	0.064	0.027	0.095	0.029	0.041	0.031	0.080	0.027	0.091	1.000	0.187	0.177	0.300	0.296	0.692	0.078	-0.290	0.007	0.076	0.129	0.100	-0.078	0.121	0.099	-0.143	0.109
hotel	0.000	0.014	0.686	0.025	0.070	0.068	0.043	0.391	0.049	0.049	0.045	0.052	0.087	0.177	0.187	1.000	0.137	0.052	-0.086	0.147	0.317	0.084	-0.084	0.221	0.137	0.323	0.178	0.181	0.166	-0.014	0.046
is_canceled	0.000	0.013	0.060	0.021	0.069	0.065	0.026	0.201	0.034	0.079	0.016	0.137	0.068	0.482	0.177	0.137	1.000	0.084	0.316	0.267	0.050	-0.115	0.270	0.198	1.000	0.072	-0.859	0.041	-0.004	0.155	-0.259
is_repeated_guest	0.000	0.000	0.049	0.018	0.073	0.074	0.009	0.060	0.007	0.001	0.023	0.106	0.024	0.058	0.300	0.052	0.084	1.000	-0.188	0.349	0.062	0.762	0.154	0.079	0.085	0.037	-0.008	-0.126	-0.096	0.531	0.005
lead_time	0.013	0.190	-0.054	0.008	0.057	0.113	0.057	-0.158	-0.020	-0.007	-0.021	0.125	0.153	0.331	0.296	-0.086	0.316	-0.188	1.000	0.170	0.089	-0.189	0.171	0.057	0.207	0.051	-0.119	0.296	0.162	0.038	-0.074
market_segment	0.000	0.008	0.187	0.033	0.088	0.081	0.159	0.118	0.034	0.029	0.074	0.275	0.078	0.374	0.692	0.147	0.267	0.349	0.170	1.000	0.192	-0.211	-0.166	0.093	0.196	0.135	0.028	0.126	0.115	-0.245	0.374
meal	0.000	0.000	0.163	0.039	0.089	0.080	0.112	0.113	0.015	0.012	0.026	0.139	0.062	0.093	0.078	0.317	0.050	0.062	0.089	0.192	1.000	-0.066	-0.040	0.027	0.040	0.102	0.029	0.031	0.051	-0.068	0.029
previous_bookings_not_canceled	-0.143	-0.210	-0.035	-0.002	-0.008	-0.044	0.037	0.041	-0.011	0.031	-0.037	-0.049	-0.019	-0.064	-0.290	0.084	-0.115	0.762	-0.189	-0.211	-0.066	1.000	0.101	0.019	0.029	0.004	0.021	-0.119	-0.084	0.620	0.025
previous_cancellations	-0.150	-0.037	-0.154	-0.012	0.046	0.087	-0.258	-0.139	-0.017	-0.073	-0.061	0.002	0.116	0.318	0.007	-0.084	0.270	0.154	0.171	-0.166	-0.040	0.101	1.000	0.000	0.031	0.007	-0.249	-0.062	-0.055	0.809	-0.130
required_car_parking_spaces	0.000	0.000	0.087	0.008	0.018	0.017	0.018	0.092	0.020	0.026	0.022	0.041	0.034	0.071	0.076	0.221	0.198	0.079	0.057	0.093	0.027	0.019	0.000	1.000	0.140	0.079	0.149	-0.034	-0.019	0.023	0.088
reservation_status	0.000	0.008	0.046	0.023	0.065	0.061	0.023	0.144	0.024	0.057	0.018	0.097	0.050	0.347	0.129	0.137	1.000	0.085	0.207	0.196	0.040	0.029	0.031	0.140	1.000	0.052	0.831	-0.046	0.007	-0.159	0.254
reserved_room_type	0.000	0.004	0.121	0.010	0.048	0.044	0.082	0.744	0.040	0.018	0.337	0.109	0.028	0.152	0.100	0.323	0.072	0.037	0.051	0.135	0.102	0.004	0.007	0.079	0.052	1.000	0.127	0.170	0.142	-0.109	0.152
stay_duration	-0.010	0.033	0.138	0.002	-0.008	0.009	-0.008	0.181	0.042	0.193	0.028	0.049	-0.087	-0.421	-0.078	0.178	-0.859	-0.008	-0.119	0.028	0.029	0.021	-0.249	0.149	0.831	0.127	1.000	0.324	0.267	-0.190	0.264
stays_in_week_nights	0.093	0.153	0.180	-0.016	-0.024	0.026	0.042	0.083	0.026	0.063	0.059	-0.080	0.012	-0.056	0.121	0.181	0.041	-0.126	0.296	0.126	0.031	-0.119	-0.062	-0.034	-0.046	0.170	0.324	1.000	0.237	-0.115	0.076
stays_in_weekend_nights	0.051	0.127	0.145	-0.007	-0.035	0.026	0.025	0.080	0.023	0.039	0.058	-0.083	-0.075	-0.116	0.099	0.166	-0.004	-0.096	0.162	0.115	0.051	-0.084	-0.055	-0.019	0.007	0.142	0.267	0.237	1.000	-0.090	0.080
total_bookings	-0.200	-0.139	-0.142	-0.011	0.034	0.048	-0.194	-0.089	-0.020	-0.043	-0.069	-0.026	0.083	0.229	-0.143	-0.014	0.155	0.531	0.038	-0.245	-0.068	0.620	0.809	0.023	-0.159	-0.109	-0.190	-0.115	-0.090	1.000	-0.096
total_of_special_requests	0.197	0.162	0.035	0.003	-0.057	0.019	0.116	0.137	0.093	0.042	0.117	-0.160	-0.123	-0.302	0.109	0.046	-0.259	0.005	-0.074	0.374	0.029	0.025	-0.130	0.088	0.254	0.152	0.264	0.076	0.080	-0.096	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	booking_changes	deposit_type	agent	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date	arrival_date	stay_duration
0	Resort Hotel	0	342	2015	July	27	1	0	2	BB	PRT	Direct	Direct	C	C	3	No Deposit	9.0	Transient	0.0	0	Check-Out	2015-07-01	2015-07-01	0
1	Resort Hotel	0	737	2015	July	27	1	0	2	BB	PRT	Direct	Direct	C	C	4	No Deposit	9.0	Transient	0.0	0	Check-Out	2015-07-01	2015-07-01	0
2	Resort Hotel	0	7	2015	July	27	1	1	1	BB	GBR	Direct	Direct	A	C	0	No Deposit	9.0	Transient	75.0	0	Check-Out	2015-07-02	2015-07-01	1
3	Resort Hotel	0	13	2015	July	27	1	1	1	BB	GBR	Corporate	Corporate	A	A	0	No Deposit	304.0	Transient	75.0	0	Check-Out	2015-07-02	2015-07-01	1
4	Resort Hotel	0	14	2015	July	27	1	2	2	BB	GBR	Online TA	TA/TO	A	A	0	No Deposit	240.0	Transient	98.0	1	Check-Out	2015-07-03	2015-07-01	2
5	Resort Hotel	0	14	2015	July	27	1	2	2	BB	GBR	Online TA	TA/TO	A	A	0	No Deposit	240.0	Transient	98.0	1	Check-Out	2015-07-03	2015-07-01	2
6	Resort Hotel	0	0	2015	July	27	1	2	2	BB	PRT	Direct	Direct	C	C	0	No Deposit	9.0	Transient	107.0	0	Check-Out	2015-07-03	2015-07-01	2
7	Resort Hotel	0	9	2015	July	27	1	2	2	FB	PRT	Direct	Direct	C	C	0	No Deposit	303.0	Transient	103.0	1	Check-Out	2015-07-03	2015-07-01	2
8	Resort Hotel	1	85	2015	July	27	1	3	2	BB	PRT	Online TA	TA/TO	A	A	0	No Deposit	240.0	Transient	82.0	1	Canceled	2015-05-06	2015-07-01	-1
9	Resort Hotel	1	75	2015	July	27	1	3	2	HB	PRT	Offline TA/TO	TA/TO	D	D	0	No Deposit	15.0	Transient	105.5	0	Canceled	2015-04-22	2015-07-01	-1

	hotel	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	deposit_type	agent	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date	arrival_date	stay_duration
119380	City Hotel	44	2017	August	35	31	1	3	2	SC	DEU	Online TA	TA/TO	A	A	No Deposit	9.0	Transient	140.75	1	Check-Out	2017-09-04	2017-08-31	4
119381	City Hotel	188	2017	August	35	31	2	3	2	BB	DEU	Direct	Direct	A	A	No Deposit	14.0	Transient	99.00	0	Check-Out	2017-09-05	2017-08-31	5
119382	City Hotel	135	2017	August	35	30	2	4	3	BB	JPN	Online TA	TA/TO	G	G	No Deposit	7.0	Transient	209.00	0	Check-Out	2017-09-05	2017-08-30	6
119383	City Hotel	164	2017	August	35	31	2	4	2	BB	DEU	Offline TA/TO	TA/TO	A	A	No Deposit	42.0	Transient	87.60	0	Check-Out	2017-09-06	2017-08-31	6
119384	City Hotel	21	2017	August	35	30	2	5	2	BB	BEL	Offline TA/TO	TA/TO	A	A	No Deposit	394.0	Transient	96.14	2	Check-Out	2017-09-06	2017-08-30	7
119385	City Hotel	23	2017	August	35	30	2	5	2	BB	BEL	Offline TA/TO	TA/TO	A	A	No Deposit	394.0	Transient	96.14	0	Check-Out	2017-09-06	2017-08-30	7
119386	City Hotel	102	2017	August	35	31	2	5	3	BB	FRA	Online TA	TA/TO	E	E	No Deposit	9.0	Transient	225.43	2	Check-Out	2017-09-07	2017-08-31	7
119387	City Hotel	34	2017	August	35	31	2	5	2	BB	DEU	Online TA	TA/TO	D	D	No Deposit	9.0	Transient	157.71	4	Check-Out	2017-09-07	2017-08-31	7
119388	City Hotel	109	2017	August	35	31	2	5	2	BB	GBR	Online TA	TA/TO	A	A	No Deposit	89.0	Transient	104.40	0	Check-Out	2017-09-07	2017-08-31	7
119389	City Hotel	205	2017	August	35	29	2	7	2	HB	DEU	Online TA	TA/TO	A	A	No Deposit	9.0	Transient	151.20	2	Check-Out	2017-09-07	2017-08-29	9

Most frequently occurring

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	previous_cancellations	reserved_room_type	assigned_room_type	deposit_type	agent	days_in_waiting_list	customer_type	adr	reservation_status	reservation_status_date	arrival_date	total_bookings	stay_duration	# duplicates
5400	City Hotel	1	277	2016	November	46	7	1	2	2	BB	PRT	Groups	TA/TO	0	A	A	Non Refund	9.0	0	Transient	100.0	Canceled	2016-04-04	2016-11-07	0	-1	180
4178	City Hotel	1	68	2016	February	8	17	0	2	2	BB	PRT	Groups	TA/TO	1	A	A	Non Refund	37.0	0	Transient	75.0	Canceled	2016-01-06	2016-02-17	1	-1	150
5072	City Hotel	1	188	2016	June	25	15	0	2	1	BB	PRT	Offline TA/TO	TA/TO	0	A	A	Non Refund	119.0	39	Transient	130.0	Canceled	2016-01-18	2016-06-15	0	-1	109
4876	City Hotel	1	158	2016	May	22	24	0	2	1	BB	PRT	Groups	TA/TO	0	A	A	Non Refund	37.0	31	Transient	130.0	Canceled	2016-01-18	2016-05-24	0	-1	101
3847	City Hotel	1	34	2015	December	50	8	0	2	1	BB	PRT	Offline TA/TO	TA/TO	1	A	A	Non Refund	19.0	0	Transient	90.0	Canceled	2015-11-17	2015-12-08	1	-1	100
3789	City Hotel	1	28	2017	March	9	2	0	3	2	BB	PRT	Groups	TA/TO	0	A	A	Non Refund	9.0	0	Transient	95.0	Canceled	2017-02-02	2017-03-02	0	-1	99
3903	City Hotel	1	38	2017	January	2	14	0	1	1	BB	PRT	Corporate	Corporate	0	A	A	Non Refund	9.0	0	Transient	75.0	Canceled	2016-12-07	2017-01-14	0	-1	99
4869	City Hotel	1	156	2017	April	17	26	0	3	2	BB	PRT	Groups	TA/TO	0	A	A	Non Refund	37.0	0	Transient	100.0	Canceled	2016-11-21	2017-04-26	0	-1	99
4202	City Hotel	1	71	2016	June	25	14	0	3	1	BB	PRT	Offline TA/TO	TA/TO	0	A	A	Non Refund	236.0	0	Transient	120.0	Canceled	2016-04-27	2016-06-14	0	-1	89
4936	City Hotel	1	166	2016	November	45	1	0	3	1	BB	PRT	Offline TA/TO	TA/TO	0	A	A	Non Refund	236.0	0	Transient	110.0	Canceled	2016-07-13	2016-11-01	0	-1	85

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Most occurring scripts

Most frequent character per script